c21acdfb992c79570072bad2280fc6cf19b7e57a,src/spade/storage/SQL.java,SQL,getNeighborVertexIds,#number#,603
Before Change
try {
dbConnection.commit();
// TODO: Handle exception case when getVertexFromId returns null
String query = "SELECT dstVertexHash FROM edge WHERE srcVertexHash = " + getVertexFromId(vertexId).hashCode();
Statement statement = dbConnection.createStatement();
ResultSet result = statement.executeQuery(query);
while (result.next()) {
After Change
dbConnection.commit();
// TODO: Handle exception case when getVertexFromId returns null
String query = "SELECT vertexId FROM vertex WHERE hash IN (SELECT dstVertexHash FROM edge WHERE " +
"srcVertexHash = " + getVertexFromId(vertexId).getAnnotation("hash") + ")";
Statement statement = dbConnection.createStatement();
ResultSet result = statement.executeQuery(query);
while (result.next())